You are here: Pega 7 Platform Database > Database tables and columns > Property optimization > Populating database columns using the service-enabled Column Populator utility

Populating database columns using the service-enabled Column Populator utility

You can populate column values of a table that contains rows after a change to a table schema using the Database Column Populator.

  1. ClosedConfigure the common properties in the prpcServiceUtils.properties file.

    prpcServiceUtils.properties file property name Action
    pega.rest.server.url

    Enter the URL for the REST service in the following format:

    http://<hostname>:<port>/context/PRRestService/tenanthash

    Include the tenant hash only for multitenant systems.
    pega.rest.username Enter the operator name on the target system with access to REST services.
    pega.rest.password Enter the password of the specified operator.
    pega.rest.proxy.host Enter the host name of the REST proxy server. Do not use localhost as the host name.
    pega.rest.proxy.port Enter the port for the REST proxy server.
    pega.rest.proxy.username Enter the operator name on the REST proxy server with import and export access.
    pega.rest.proxy.password Enter the password of the REST proxy operator.
    pega.rest.proxy.domain Enter the domain of the REST proxy server.
    pega.rest.proxy.workstation Optional: Enter the workstation ID for the REST proxy server.
    user.temp.dir Optional: Enter the full path to the temporary directory. Leave this blank to use the default temporary directory.

  2. Configure the classes.

    To specify the data to expose, Use the include and exclude classes. For example, if you include Rule- with descendants and exclude Rule-File- with descendants, the Pega 7 Platform processes everything in Rule-, except rules in Rule-File-.

    ClosedClasses to include (required)
    prpcServiceUtils.properties file property nameAction
    expose.includedClasses

    Enter a comma-separated list of classes to include in the column. If you plan to specify a range of keys from pzInsKey, you must specify one class with no descendants.

    expose.includeDescendentsOptional: Set to true to exclude descendants of included classes.
    ClosedClasses to exclude
    prpcServiceUtils.properties file property nameAction
    expose.excludedClasses

    Enter a comma-separated list of classes to exclude from the column.

    expose.excludeDescendentsOptional: Set to true to exclude descendants of excluded classes.

  3. ClosedOptional: Configure the access group.

    prpcServiceUtils.properties file property name Action
    expose.accessGroup

    Enter the access group for the Rule-Declare-Index of the classes being exposed.

    To regenerate indexes, enter an access group or the REST user name and password (prpc.rest.proxy.username and prpc.rest.proxy.password in the common properties section). If you enter both an access group and a user name, the user name takes precedence over the access group.

  4. ClosedConfigure the keys or date ranges to expose.

    Specify the range of pzInsKey or pxCreateDateTime values to expose. If you specify both, the pzInsKey values override the pxCreateDateTime values.

    prpcServiceUtils.properties file property name Action
    expose.startKey Enter the minimum value for pzInsKey. The system will export data equal to or greater than this value.
    expose.endKey Enter the maximum value for pzInsKey. The system will export data equal to or less than this value.
    expose.startDate Enter the minimum value for pxCreateDateTime. The system will export data equal to or greater than this value.
    expose.endDate Enter the maximum value for pxCreateDateTime. The system will export data equal to or less than this value.
  5. ClosedConfigure the reindexing behavior.
    prpcServiceUtils.properties file property name Action
    expose.reindex

    Specify whether to regenerate the database. The default is true.

    To expose property references, set expose.reindex=true.

    To regenerate indexes, enter an access group or the REST user name and password (prpc.rest.proxy.username and prpc.rest.proxy.password in the common properties section). If you enter both an access group and a user name, the user name takes precedence over the access group.

    expose.reindexType

    To maximize performance, process Pega 7 Platform rulesets only when instructed to do so by Pegasystems Global Customer Support. Specify which rulesets to re-index:

    • nonpega: (Default) process only customer rulesets
    • full: process Pega 7 Platform and customer rulesets
    • pega: process only Pega 7 Platform rulesets

    To maximize performance, process Pega 7 Platform rulesets only when instructed to do so by Pegasystems Global Customer Support.
    expose.commitRate

    Specify the number of data instances processed with each database commit to balance memory usage and performance. The default of 100 is sufficient for most environments.
    expose.jobID Optional: To query the job status, uncomment this field and specify the job ID.
    expose.async Specify whether to run the expose operation in asynchronous mode and queue the request. Default is true.

  6. Save and close the prpcServiceUtils.properties file.

  7. Run the prpcServiceUtils.bat or prpcServiceUtils.sh script . For asynchronous operations, the system response includes the job status by job ID.

Related information

Open topic with navigation